Forum Discussion
auto-refresh in PowerBI workspace with sharepoint data source
Anonymous,
Check if the following link helps.
- Anonymous8 years agoNot applicable
I don't think that link helps my problem. To be more specific, when I using the workspace in my internet browser and refresh the dataset, the refresh goes through but the data does not show up correctly on the graphs. However, when I refresh the same dataset but do it within the Power BI desktop application, the data reflects what is in the Sharepoint database and everything looks good.
In the workspace, when I view the Dataset tab for this report, I see under the "Gateway connection" section the following: "You don't need a gateway for this dataset, because all of its data sources are in the cloud, but you can use a gateway for enhanced control over how you connect." So perhaps that is not the issue.
Under data source credentials, I have edited my credentials to OAuth2 authentication method, but whenever I go back to check this again, the dialog box opens up and it shows "Anonymous" as the default sign-in. Does this mean I am not using OAuth2 authentication?
My suspicion that the issue is somewhere here since again, I can refresh in desktop but not in the online workspace. Perhaps I am wrong though?
- Anonymous8 years agoNot applicable
I've done some more investigating after doing the workspace refresh. For background, the project uses 4 lists from sharepoint (Links, Project Info, Stakeholders, and Actions). I have another table I created in PowerBI called "Program Name".
When I refresh, I see that the visuals that use the "Project Info", "Stakeholders", and "Links" sharepoint lists refresh without issue. It is the "Actions" list that is not refreshing correctly - it just shows up blank.
Must be an issue with this list then... I'll keep digging in the meantime.
- manjirit7 years ago
Helper I
I have a similar issue. I have a Power BI file that is using Excel file on Sharepoint as data souces. When I refresh the dataset from Power BI desktop, it goes through without any problem but the refresh for the file published on the Power BI service fails with "Edit Credentials" message.
what is happening?
